Develop and Use Complex Spreadsheets: Getting Results: Excel 2016 by Tilde Publishing

Author:Tilde Publishing [Publishing, Tilde]
Language: eng
Format: mobi
Tags: Spreadsheet skills reviewed, Functions in Excel, Using logical functions, Creating and editing templates, Tools for summarising data, Creating PivotTables and Pivot Charts, Linking Excel data to other programs, Useful text functions, Creating macros., Conditional formatting, Viewing and adjusting worksheets, Importing & exporting data, Formulas in Excel, Using maths functions, Charting and pictures in Excel, Using date & time functions, Useful database functions, Using lookup functions, Using statistical functions, Working with data in tables, Using financial functions
ISBN: 9780734608864
Publisher: Tilde
Published: 2017-03-19T04:00:00+00:00

Adding data to your table

Excel automatically assumes you are adding a new row if you type data in the row beneath the table.

How to: Insert new data to the end of a table

Click in the first column in the first row below the table.

Enter the required data.

As soon as you press or a new row is inserted and the

table border moves down.

Hints & tips

You can add a new row or column to your table above or to the left of the current cell. Display the Home ribbon and click on the top-half of the Insert button (Cells group).

You can resize a table. Position your mouse pointer over the resize handle in the bottom right corner of the table. The mouse pointer becomes a double-headed arrow. Drag the handle to the new size. This can add new rows or new columns (with a default heading). If you make the table smaller, data is excluded from the table (although still shown on the sheet).

Hands-on exercise 37

In this exercise you practise adding data your table.

Ensure the workbook Staff car leases is open.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.